<test>
  <sql>WITH SortedEmps AS
(
	SELECT	*
	FROM	Employees
	ORDER	BY 1
)
SELECT	*
FROM	SortedEmps</sql>
  <expectedErrors>
    <expectedError id="OrderByInvalidInSubqueryUnlessTopIsAlsoSpecified" text="The ORDER BY clause is invalid in derived tables, subqueries, and common table expressions, unless TOP is also specified." />
  </expectedErrors>
</test>